| Author |
Thread Statistics | Show CCP posts - 9 post(s) |
Cesar Malari
Gunfleet Logistics
   |
Posted - 2008.07.30 16:10:00 -
[1]
 Quote:
Removal of table crpNPCCorporationTrades.
Can someone at CCP say why this was done?
I was just in the process of putting the finishing touches on a tool that used this table from the trinity data dump to find the closest place that sold a given NPC-supplied item (skillbooks, T1 BPOs, POS parts), even if it wasn't in my region. It was very helpful in helping me find where some POS parts were being sold. |
Cesar Malari
Gunfleet Logistics
|
Posted - 2008.07.30 16:27:00 -
[2]
Originally by: Meissa Anunthiel
Anyone knows how to get the T2 BPC produced when using invention on T1 BPOs? I can't seem to find that information in the dump (there's a workaround with joining invBlueprintTypes and invTypes and checking techlevel 1 or 2, but that doesn't work for ammo)
From the T1 BPC, get the item produced by it (invBluePrintTypes.productTypeID), then find the T2 item(s) by looking in invMetaTypes.typeID where metaGroupID=2 and parentTypeID=the T1 item typeid. Match the T2 item id to invBluePrintTypes.productTypeID, giving you the BP's item ID as blueprintTypeID.
Example for Null L:
select * from invTypes where typename='Thorium Charge L Blueprint'
select * from invBlueprintTypes where blueprintTypeID=1150
select * from invMetaTypes where parentTypeID=235 and metaGroupID=2
select * from invBlueprintTypes where productTypeID=12787
select * from invTypes where typeid=12788 |
Cesar Malari
Gunfleet Logistics
|
Posted - 2008.07.30 17:07:00 -
[3]
Originally by: Nekopyat
Though one question (less at the devs and more at others), can anyone suggest a quick way to get this data OUT of MSSQL without having to grab a copy from microsoft?
Be patient. Within a day or so, someone will have exported the data to a SQL script for MySQL, CSV files, and probably even an Access file and posted links to either this thread, or some one in "EVE Technology Lab" forum. They won't be "official" of course, but someone will probably do it if you can't be bothered to install SQL Server Express yourself.
If noone does a MySQL one by this weekend, I'll probably throw one together. |
Cesar Malari
Gunfleet Logistics
|
Posted - 2008.07.31 14:12:00 -
[4]
Originally by: CCP Prism X
Why is crpNPCCorporationTrades missing?
Well, it should really never have been included. This is basicaly meta-data and could allow people to get an advantage they couldn't otherwise get in game. Something like finding out what is being sold in regions they've never been in would be a good example. Finding the best possible trade routes through some datamining would be another. 
I'm sorry if the mismatch has wasted anyones time.
Well, I don't think it could help find "best possible trade routes", as it doesn't have the day-to-day pricing fluxuations, but I can see why you might be concerned. Any thoughts on adding something to the item database that at least uses that data to list the companies that sell a particular item? Sometimes when you're building a POS or need a specific skill, it's hard to remember where it is you have to go to pick it up. At least knowing a corp name, we could use existing tools. |
Cesar Malari
Gunfleet Logistics
|
Posted - 2008.08.01 14:42:00 -
[5]
Originally by: Kojebo
What's the 'technical reason' for not implementing foreign keys?
If I had to guess, it's not so much a "technical" reason as a "performance" reason. If you have the FKs on there, they are checked for each insert/update, which takes time. In case you hadn't noticed, database performance is a giant issue for this game, so they likely don't have FKs on the live database.
Now, as to why they don't add them to the export, well, that one I can't think of a reason for, other than that they don't want to bother doing it. Remember -- they're trying to get a nice, easy, repeatable process for themselves here.... |
Cesar Malari
Gunfleet Logistics
|
Posted - 2008.08.01 14:44:00 -
[6]
Edited by: Cesar Malari on 01/08/2008 14:44:56
Originally by: BigWhale
One question, is MS SQL unable to produce an ANSI SQL text dump?
Natively? No. SQL Server doesn't ship with a tool like mysqldump.
However, there is such a tool available -- the Database Publishing Wizard. Point it at a DB and it builds SQL scripts for the schema and/or data. I think this tool is also included in VS 2008.
In fact, I was already kicked off that tool to dump the SQL out for my own MySQL export when I saw the community-provided ones were available, so never bothered to finish it. |
Cesar Malari
Gunfleet Logistics
|
Posted - 2008.08.01 16:00:00 -
[7]
Edited by: Cesar Malari on 01/08/2008 16:01:29
Originally by: Ami Nia
To begin with, CCP is supposedly supporting EvE on multiple platforms.
I don't believe CCP officially supports anything other than the EvE client on multiple platforms. The data dumps at this point exist as more of a "here, see what you can do with this" than an officially supported released product. Case in point: how long it took after the patch before we got this dump.
Would it be better if CCP supplied this data in a more open format? Yes. However, if CCP doesn't feel it's worth their time to do the conversion, I'd rather they gave us what they've given us than nothing at all. In fact, if I had to choose one of two directions for further work on the data dump: make the export more cross-platform or include more data in the export, I'd pick #2. The community can convert the data rather easily. We can't see the data that's not released.
Constructive suggestions are good (ie. the discussion over crpNPCCorporationTrades and the suggesting a more open format). Whining about the lack of 'official' support (I quote official here because none of this is officially supported -- try filing a petition about it) for our chosen platform mak may make them think we don't appreciate what they've given us. Which we do. We like having more data and more up-to-date data to play with. |
| |
|